﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_InsertBasicReference_Location')
	BEGIN
		DROP  Procedure  esf_sso.P_InsertBasicReference_Location
	END
GO

CREATE PROCEDURE esf_sso.P_InsertBasicReference_Location
	@pBasicReferenceID	INT
	,@pLocationID		INT
AS

	INSERT INTO esf_sso.BasicReference_Location (BasicReferenceID, LocationID) 
	SELECT @pBasicReferenceID, @pLocationID
	
GO   